To Export Groups of Clashes to an Excel Spreadsheet

From the Clash Detection dialog Results tab, make sure the column headers are in the order that you want them to display in the Excel spreadsheet.
Only columns displayed on the Results tab are exported to Excel.
Group the clashes as needed.
Select Results > Export All > Excel/CSV.
The Export Excel/CSV File dialog opens.
Name the file and click Save. The default file name is Clashes.xlsx.
Open the Excel spreadsheet to view the clashes.
Listed first are the individual groups and clashes followed by the groups with the clash details included in each group.